Multidimensional Database Design via Schema Transformation: Turning TPC-H into the TPC-H*d Multidimensional Benchmark
نویسندگان
چکیده
Compared to relational databases, multidimensional database systems enhance data presentation and navigation through intuitive spreadsheet like views and increase performance through aggregated data. In this paper, we present a framework for automating multidimensional database schema design. We successfully used the framework to revolve the well known TPC-H benchmark to become a multidimensional benchmark -TPC-H*d benchmark, and translated into MDX language (MultiDimensional eXpressions) the TPC-H workload. In order to assess the effectiveness and the efficiency of our proposal, we benchmark the open source Mondrian ROLAP server and its OLAP4j driver with TPC-H*d benchmark.
منابع مشابه
AutoMDB: A Framework for Automated Multidimensional Database Design via Schema Transformation
In this paper, we demonstrate AutoMDB -a framework for automated multidimensional database design. In order to prove the effectiveness and the reliability of our proposal, we tested it over the well-known TPC-H benchmark.
متن کاملA Review of Star Schema Benchmark
This paper examines the Star Schema Benchmark, an alternative to the flawed TPC-H decision support system and presents reasons why this benchmark should be adopted over the industry standard for decision support systems. Keywords—TPC-H; databases; star schema benchmark; DBMS; profiling;
متن کاملTPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark
The TPC-D benchmark was developed almost 20 years ago, and even though its current existence as TPC-H could be considered superseded by TPC-DS, one can still learn from it. We focus on the technical level, summarizing the challenges posed by the TPC-H workload as we now understand them, which we call “choke points”. We identify 28 different such choke points, grouped into six categories: Aggreg...
متن کاملA Paradigm Shift in Database Optimization: from Indices to Aggregates
Multidimensional databases and online analytical processing (OLAP) tools provide new ways for decision-makers to access data and retrieve information. This paper examines the differences between the optimization techniques that database designers need to consider when developing relational versus multidimensional data warehouses. The multidimensional data storage model allows for large numbers ...
متن کاملIntegrating Open Sources and Relational Data with SPARQL
We believe that the possibility to use SPARQL as a front end to heterogeneous data without significant cost in performance or expressive power is key to RDF taking its rightful place as the lingua franca of data integration. To this effect, we demonstrate how RDF and SPARQL can tackle a mix of standard relational workload and data mining in public data sources. We discuss extending SPARQL for b...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2013